Using the Set Alias command

  1. With a report open in the active window, choose the Set Alias command from the Database menu. The Set Alias dialog box appears. The Databases list contains a list of aliases used in the current report, and the first alias on the list is highlighted. The Location box at the bottom of the dialog box indicates the name and path of the database that is using the highlighted alias.
  2. Select the alias of interest and click the Set Alias button. The Alias Name dialog box appears with the alias displayed in the Alias Name box.
  3. Type your new alias in the Alias Name box, and then click OK. The program returns you to the Set Alias dialog box. The new alias has replaced the old alias in the Databases box but the location remains the same.
  4. Click Done. The program replaces the old alias with the new one. Fields already placed in the report using the old alias are now identified with the new alias ({old.fieldname} is now {new.fieldname}).

    The Set Alias command does not affect the aliases used in formulas. When you change an alias, you must make certain that you change any formula references to the old alias as well. For example, if you change the "company" alias to "customer", you must make certain that you change any formula references to that alias from {company.fieldname} to {customer.fieldname}. If you don't, the program will not be able to locate the referenced field, and it will return an error message. Formula references include both formulas used in the report and selection formulas.

Note:    Set Alias changes the alias only, not the database location. If you want to change the location of a database (if you want to find the database in a new location), choose the Set Location command from the Database menu.

Related topics

Set Alias command



Seagate Software IMG Holdings, Inc.
http://www.seagatesoftware.com
Support services:
http://support.seagatesoftware.com